package com.cn.dream_order_server.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public OrderOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("order_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("order_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(String value) {
            addCriterion("order_id =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(String value) {
            addCriterion("order_id <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(String value) {
            addCriterion("order_id >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("order_id >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(String value) {
            addCriterion("order_id <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(String value) {
            addCriterion("order_id <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLike(String value) {
            addCriterion("order_id like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotLike(String value) {
            addCriterion("order_id not like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<String> values) {
            addCriterion("order_id in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<String> values) {
            addCriterion("order_id not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(String value1, String value2) {
            addCriterion("order_id between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(String value1, String value2) {
            addCriterion("order_id not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("user_id is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(String value) {
            addCriterion("user_id =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(String value) {
            addCriterion("user_id <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(String value) {
            addCriterion("user_id >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("user_id >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(String value) {
            addCriterion("user_id <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(String value) {
            addCriterion("user_id <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLike(String value) {
            addCriterion("user_id like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotLike(String value) {
            addCriterion("user_id not like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<String> values) {
            addCriterion("user_id in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<String> values) {
            addCriterion("user_id not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(String value1, String value2) {
            addCriterion("user_id between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(String value1, String value2) {
            addCriterion("user_id not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andSiteIdIsNull() {
            addCriterion("site_id is null");
            return (Criteria) this;
        }

        public Criteria andSiteIdIsNotNull() {
            addCriterion("site_id is not null");
            return (Criteria) this;
        }

        public Criteria andSiteIdEqualTo(String value) {
            addCriterion("site_id =", value, "siteId");
            return (Criteria) this;
        }

        public Criteria andSiteIdNotEqualTo(String value) {
            addCriterion("site_id <>", value, "siteId");
            return (Criteria) this;
        }

        public Criteria andSiteIdGreaterThan(String value) {
            addCriterion("site_id >", value, "siteId");
            return (Criteria) this;
        }

        public Criteria andSiteIdGreaterThanOrEqualTo(String value) {
            addCriterion("site_id >=", value, "siteId");
            return (Criteria) this;
        }

        public Criteria andSiteIdLessThan(String value) {
            addCriterion("site_id <", value, "siteId");
            return (Criteria) this;
        }

        public Criteria andSiteIdLessThanOrEqualTo(String value) {
            addCriterion("site_id <=", value, "siteId");
            return (Criteria) this;
        }

        public Criteria andSiteIdLike(String value) {
            addCriterion("site_id like", value, "siteId");
            return (Criteria) this;
        }

        public Criteria andSiteIdNotLike(String value) {
            addCriterion("site_id not like", value, "siteId");
            return (Criteria) this;
        }

        public Criteria andSiteIdIn(List<String> values) {
            addCriterion("site_id in", values, "siteId");
            return (Criteria) this;
        }

        public Criteria andSiteIdNotIn(List<String> values) {
            addCriterion("site_id not in", values, "siteId");
            return (Criteria) this;
        }

        public Criteria andSiteIdBetween(String value1, String value2) {
            addCriterion("site_id between", value1, value2, "siteId");
            return (Criteria) this;
        }

        public Criteria andSiteIdNotBetween(String value1, String value2) {
            addCriterion("site_id not between", value1, value2, "siteId");
            return (Criteria) this;
        }

        public Criteria andPaytypeIdIsNull() {
            addCriterion("payType_id is null");
            return (Criteria) this;
        }

        public Criteria andPaytypeIdIsNotNull() {
            addCriterion("payType_id is not null");
            return (Criteria) this;
        }

        public Criteria andPaytypeIdEqualTo(String value) {
            addCriterion("payType_id =", value, "paytypeId");
            return (Criteria) this;
        }

        public Criteria andPaytypeIdNotEqualTo(String value) {
            addCriterion("payType_id <>", value, "paytypeId");
            return (Criteria) this;
        }

        public Criteria andPaytypeIdGreaterThan(String value) {
            addCriterion("payType_id >", value, "paytypeId");
            return (Criteria) this;
        }

        public Criteria andPaytypeIdGreaterThanOrEqualTo(String value) {
            addCriterion("payType_id >=", value, "paytypeId");
            return (Criteria) this;
        }

        public Criteria andPaytypeIdLessThan(String value) {
            addCriterion("payType_id <", value, "paytypeId");
            return (Criteria) this;
        }

        public Criteria andPaytypeIdLessThanOrEqualTo(String value) {
            addCriterion("payType_id <=", value, "paytypeId");
            return (Criteria) this;
        }

        public Criteria andPaytypeIdLike(String value) {
            addCriterion("payType_id like", value, "paytypeId");
            return (Criteria) this;
        }

        public Criteria andPaytypeIdNotLike(String value) {
            addCriterion("payType_id not like", value, "paytypeId");
            return (Criteria) this;
        }

        public Criteria andPaytypeIdIn(List<String> values) {
            addCriterion("payType_id in", values, "paytypeId");
            return (Criteria) this;
        }

        public Criteria andPaytypeIdNotIn(List<String> values) {
            addCriterion("payType_id not in", values, "paytypeId");
            return (Criteria) this;
        }

        public Criteria andPaytypeIdBetween(String value1, String value2) {
            addCriterion("payType_id between", value1, value2, "paytypeId");
            return (Criteria) this;
        }

        public Criteria andPaytypeIdNotBetween(String value1, String value2) {
            addCriterion("payType_id not between", value1, value2, "paytypeId");
            return (Criteria) this;
        }

        public Criteria andPlaceTimeIsNull() {
            addCriterion("place_time is null");
            return (Criteria) this;
        }

        public Criteria andPlaceTimeIsNotNull() {
            addCriterion("place_time is not null");
            return (Criteria) this;
        }

        public Criteria andPlaceTimeEqualTo(Date value) {
            addCriterion("place_time =", value, "placeTime");
            return (Criteria) this;
        }

        public Criteria andPlaceTimeNotEqualTo(Date value) {
            addCriterion("place_time <>", value, "placeTime");
            return (Criteria) this;
        }

        public Criteria andPlaceTimeGreaterThan(Date value) {
            addCriterion("place_time >", value, "placeTime");
            return (Criteria) this;
        }

        public Criteria andPlaceTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("place_time >=", value, "placeTime");
            return (Criteria) this;
        }

        public Criteria andPlaceTimeLessThan(Date value) {
            addCriterion("place_time <", value, "placeTime");
            return (Criteria) this;
        }

        public Criteria andPlaceTimeLessThanOrEqualTo(Date value) {
            addCriterion("place_time <=", value, "placeTime");
            return (Criteria) this;
        }

        public Criteria andPlaceTimeIn(List<Date> values) {
            addCriterion("place_time in", values, "placeTime");
            return (Criteria) this;
        }

        public Criteria andPlaceTimeNotIn(List<Date> values) {
            addCriterion("place_time not in", values, "placeTime");
            return (Criteria) this;
        }

        public Criteria andPlaceTimeBetween(Date value1, Date value2) {
            addCriterion("place_time between", value1, value2, "placeTime");
            return (Criteria) this;
        }

        public Criteria andPlaceTimeNotBetween(Date value1, Date value2) {
            addCriterion("place_time not between", value1, value2, "placeTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNull() {
            addCriterion("pay_time is null");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNotNull() {
            addCriterion("pay_time is not null");
            return (Criteria) this;
        }

        public Criteria andPayTimeEqualTo(Date value) {
            addCriterion("pay_time =", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotEqualTo(Date value) {
            addCriterion("pay_time <>", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThan(Date value) {
            addCriterion("pay_time >", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pay_time >=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThan(Date value) {
            addCriterion("pay_time <", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThanOrEqualTo(Date value) {
            addCriterion("pay_time <=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeIn(List<Date> values) {
            addCriterion("pay_time in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotIn(List<Date> values) {
            addCriterion("pay_time not in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeBetween(Date value1, Date value2) {
            addCriterion("pay_time between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotBetween(Date value1, Date value2) {
            addCriterion("pay_time not between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayModeIsNull() {
            addCriterion("pay_mode is null");
            return (Criteria) this;
        }

        public Criteria andPayModeIsNotNull() {
            addCriterion("pay_mode is not null");
            return (Criteria) this;
        }

        public Criteria andPayModeEqualTo(String value) {
            addCriterion("pay_mode =", value, "payMode");
            return (Criteria) this;
        }

        public Criteria andPayModeNotEqualTo(String value) {
            addCriterion("pay_mode <>", value, "payMode");
            return (Criteria) this;
        }

        public Criteria andPayModeGreaterThan(String value) {
            addCriterion("pay_mode >", value, "payMode");
            return (Criteria) this;
        }

        public Criteria andPayModeGreaterThanOrEqualTo(String value) {
            addCriterion("pay_mode >=", value, "payMode");
            return (Criteria) this;
        }

        public Criteria andPayModeLessThan(String value) {
            addCriterion("pay_mode <", value, "payMode");
            return (Criteria) this;
        }

        public Criteria andPayModeLessThanOrEqualTo(String value) {
            addCriterion("pay_mode <=", value, "payMode");
            return (Criteria) this;
        }

        public Criteria andPayModeLike(String value) {
            addCriterion("pay_mode like", value, "payMode");
            return (Criteria) this;
        }

        public Criteria andPayModeNotLike(String value) {
            addCriterion("pay_mode not like", value, "payMode");
            return (Criteria) this;
        }

        public Criteria andPayModeIn(List<String> values) {
            addCriterion("pay_mode in", values, "payMode");
            return (Criteria) this;
        }

        public Criteria andPayModeNotIn(List<String> values) {
            addCriterion("pay_mode not in", values, "payMode");
            return (Criteria) this;
        }

        public Criteria andPayModeBetween(String value1, String value2) {
            addCriterion("pay_mode between", value1, value2, "payMode");
            return (Criteria) this;
        }

        public Criteria andPayModeNotBetween(String value1, String value2) {
            addCriterion("pay_mode not between", value1, value2, "payMode");
            return (Criteria) this;
        }

        public Criteria andOrderTotalIsNull() {
            addCriterion("order_total is null");
            return (Criteria) this;
        }

        public Criteria andOrderTotalIsNotNull() {
            addCriterion("order_total is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTotalEqualTo(Integer value) {
            addCriterion("order_total =", value, "orderTotal");
            return (Criteria) this;
        }

        public Criteria andOrderTotalNotEqualTo(Integer value) {
            addCriterion("order_total <>", value, "orderTotal");
            return (Criteria) this;
        }

        public Criteria andOrderTotalGreaterThan(Integer value) {
            addCriterion("order_total >", value, "orderTotal");
            return (Criteria) this;
        }

        public Criteria andOrderTotalGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_total >=", value, "orderTotal");
            return (Criteria) this;
        }

        public Criteria andOrderTotalLessThan(Integer value) {
            addCriterion("order_total <", value, "orderTotal");
            return (Criteria) this;
        }

        public Criteria andOrderTotalLessThanOrEqualTo(Integer value) {
            addCriterion("order_total <=", value, "orderTotal");
            return (Criteria) this;
        }

        public Criteria andOrderTotalIn(List<Integer> values) {
            addCriterion("order_total in", values, "orderTotal");
            return (Criteria) this;
        }

        public Criteria andOrderTotalNotIn(List<Integer> values) {
            addCriterion("order_total not in", values, "orderTotal");
            return (Criteria) this;
        }

        public Criteria andOrderTotalBetween(Integer value1, Integer value2) {
            addCriterion("order_total between", value1, value2, "orderTotal");
            return (Criteria) this;
        }

        public Criteria andOrderTotalNotBetween(Integer value1, Integer value2) {
            addCriterion("order_total not between", value1, value2, "orderTotal");
            return (Criteria) this;
        }

        public Criteria andSerialNumberIsNull() {
            addCriterion("serial_number is null");
            return (Criteria) this;
        }

        public Criteria andSerialNumberIsNotNull() {
            addCriterion("serial_number is not null");
            return (Criteria) this;
        }

        public Criteria andSerialNumberEqualTo(String value) {
            addCriterion("serial_number =", value, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberNotEqualTo(String value) {
            addCriterion("serial_number <>", value, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberGreaterThan(String value) {
            addCriterion("serial_number >", value, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberGreaterThanOrEqualTo(String value) {
            addCriterion("serial_number >=", value, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberLessThan(String value) {
            addCriterion("serial_number <", value, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberLessThanOrEqualTo(String value) {
            addCriterion("serial_number <=", value, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberLike(String value) {
            addCriterion("serial_number like", value, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberNotLike(String value) {
            addCriterion("serial_number not like", value, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberIn(List<String> values) {
            addCriterion("serial_number in", values, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberNotIn(List<String> values) {
            addCriterion("serial_number not in", values, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberBetween(String value1, String value2) {
            addCriterion("serial_number between", value1, value2, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andSerialNumberNotBetween(String value1, String value2) {
            addCriterion("serial_number not between", value1, value2, "serialNumber");
            return (Criteria) this;
        }

        public Criteria andDiscountsMoneyIsNull() {
            addCriterion("discounts_money is null");
            return (Criteria) this;
        }

        public Criteria andDiscountsMoneyIsNotNull() {
            addCriterion("discounts_money is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountsMoneyEqualTo(Integer value) {
            addCriterion("discounts_money =", value, "discountsMoney");
            return (Criteria) this;
        }

        public Criteria andDiscountsMoneyNotEqualTo(Integer value) {
            addCriterion("discounts_money <>", value, "discountsMoney");
            return (Criteria) this;
        }

        public Criteria andDiscountsMoneyGreaterThan(Integer value) {
            addCriterion("discounts_money >", value, "discountsMoney");
            return (Criteria) this;
        }

        public Criteria andDiscountsMoneyGreaterThanOrEqualTo(Integer value) {
            addCriterion("discounts_money >=", value, "discountsMoney");
            return (Criteria) this;
        }

        public Criteria andDiscountsMoneyLessThan(Integer value) {
            addCriterion("discounts_money <", value, "discountsMoney");
            return (Criteria) this;
        }

        public Criteria andDiscountsMoneyLessThanOrEqualTo(Integer value) {
            addCriterion("discounts_money <=", value, "discountsMoney");
            return (Criteria) this;
        }

        public Criteria andDiscountsMoneyIn(List<Integer> values) {
            addCriterion("discounts_money in", values, "discountsMoney");
            return (Criteria) this;
        }

        public Criteria andDiscountsMoneyNotIn(List<Integer> values) {
            addCriterion("discounts_money not in", values, "discountsMoney");
            return (Criteria) this;
        }

        public Criteria andDiscountsMoneyBetween(Integer value1, Integer value2) {
            addCriterion("discounts_money between", value1, value2, "discountsMoney");
            return (Criteria) this;
        }

        public Criteria andDiscountsMoneyNotBetween(Integer value1, Integer value2) {
            addCriterion("discounts_money not between", value1, value2, "discountsMoney");
            return (Criteria) this;
        }

        public Criteria andActivitytypeIdIsNull() {
            addCriterion("activityType_id is null");
            return (Criteria) this;
        }

        public Criteria andActivitytypeIdIsNotNull() {
            addCriterion("activityType_id is not null");
            return (Criteria) this;
        }

        public Criteria andActivitytypeIdEqualTo(String value) {
            addCriterion("activityType_id =", value, "activitytypeId");
            return (Criteria) this;
        }

        public Criteria andActivitytypeIdNotEqualTo(String value) {
            addCriterion("activityType_id <>", value, "activitytypeId");
            return (Criteria) this;
        }

        public Criteria andActivitytypeIdGreaterThan(String value) {
            addCriterion("activityType_id >", value, "activitytypeId");
            return (Criteria) this;
        }

        public Criteria andActivitytypeIdGreaterThanOrEqualTo(String value) {
            addCriterion("activityType_id >=", value, "activitytypeId");
            return (Criteria) this;
        }

        public Criteria andActivitytypeIdLessThan(String value) {
            addCriterion("activityType_id <", value, "activitytypeId");
            return (Criteria) this;
        }

        public Criteria andActivitytypeIdLessThanOrEqualTo(String value) {
            addCriterion("activityType_id <=", value, "activitytypeId");
            return (Criteria) this;
        }

        public Criteria andActivitytypeIdLike(String value) {
            addCriterion("activityType_id like", value, "activitytypeId");
            return (Criteria) this;
        }

        public Criteria andActivitytypeIdNotLike(String value) {
            addCriterion("activityType_id not like", value, "activitytypeId");
            return (Criteria) this;
        }

        public Criteria andActivitytypeIdIn(List<String> values) {
            addCriterion("activityType_id in", values, "activitytypeId");
            return (Criteria) this;
        }

        public Criteria andActivitytypeIdNotIn(List<String> values) {
            addCriterion("activityType_id not in", values, "activitytypeId");
            return (Criteria) this;
        }

        public Criteria andActivitytypeIdBetween(String value1, String value2) {
            addCriterion("activityType_id between", value1, value2, "activitytypeId");
            return (Criteria) this;
        }

        public Criteria andActivitytypeIdNotBetween(String value1, String value2) {
            addCriterion("activityType_id not between", value1, value2, "activitytypeId");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIdIsNull() {
            addCriterion("orderType_id is null");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIdIsNotNull() {
            addCriterion("orderType_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIdEqualTo(String value) {
            addCriterion("orderType_id =", value, "ordertypeId");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIdNotEqualTo(String value) {
            addCriterion("orderType_id <>", value, "ordertypeId");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIdGreaterThan(String value) {
            addCriterion("orderType_id >", value, "ordertypeId");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIdGreaterThanOrEqualTo(String value) {
            addCriterion("orderType_id >=", value, "ordertypeId");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIdLessThan(String value) {
            addCriterion("orderType_id <", value, "ordertypeId");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIdLessThanOrEqualTo(String value) {
            addCriterion("orderType_id <=", value, "ordertypeId");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIdLike(String value) {
            addCriterion("orderType_id like", value, "ordertypeId");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIdNotLike(String value) {
            addCriterion("orderType_id not like", value, "ordertypeId");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIdIn(List<String> values) {
            addCriterion("orderType_id in", values, "ordertypeId");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIdNotIn(List<String> values) {
            addCriterion("orderType_id not in", values, "ordertypeId");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIdBetween(String value1, String value2) {
            addCriterion("orderType_id between", value1, value2, "ordertypeId");
            return (Criteria) this;
        }

        public Criteria andOrdertypeIdNotBetween(String value1, String value2) {
            addCriterion("orderType_id not between", value1, value2, "ordertypeId");
            return (Criteria) this;
        }

        public Criteria andOrderOther1IsNull() {
            addCriterion("order_other1 is null");
            return (Criteria) this;
        }

        public Criteria andOrderOther1IsNotNull() {
            addCriterion("order_other1 is not null");
            return (Criteria) this;
        }

        public Criteria andOrderOther1EqualTo(String value) {
            addCriterion("order_other1 =", value, "orderOther1");
            return (Criteria) this;
        }

        public Criteria andOrderOther1NotEqualTo(String value) {
            addCriterion("order_other1 <>", value, "orderOther1");
            return (Criteria) this;
        }

        public Criteria andOrderOther1GreaterThan(String value) {
            addCriterion("order_other1 >", value, "orderOther1");
            return (Criteria) this;
        }

        public Criteria andOrderOther1GreaterThanOrEqualTo(String value) {
            addCriterion("order_other1 >=", value, "orderOther1");
            return (Criteria) this;
        }

        public Criteria andOrderOther1LessThan(String value) {
            addCriterion("order_other1 <", value, "orderOther1");
            return (Criteria) this;
        }

        public Criteria andOrderOther1LessThanOrEqualTo(String value) {
            addCriterion("order_other1 <=", value, "orderOther1");
            return (Criteria) this;
        }

        public Criteria andOrderOther1Like(String value) {
            addCriterion("order_other1 like", value, "orderOther1");
            return (Criteria) this;
        }

        public Criteria andOrderOther1NotLike(String value) {
            addCriterion("order_other1 not like", value, "orderOther1");
            return (Criteria) this;
        }

        public Criteria andOrderOther1In(List<String> values) {
            addCriterion("order_other1 in", values, "orderOther1");
            return (Criteria) this;
        }

        public Criteria andOrderOther1NotIn(List<String> values) {
            addCriterion("order_other1 not in", values, "orderOther1");
            return (Criteria) this;
        }

        public Criteria andOrderOther1Between(String value1, String value2) {
            addCriterion("order_other1 between", value1, value2, "orderOther1");
            return (Criteria) this;
        }

        public Criteria andOrderOther1NotBetween(String value1, String value2) {
            addCriterion("order_other1 not between", value1, value2, "orderOther1");
            return (Criteria) this;
        }

        public Criteria andOrderOther2IsNull() {
            addCriterion("order_other2 is null");
            return (Criteria) this;
        }

        public Criteria andOrderOther2IsNotNull() {
            addCriterion("order_other2 is not null");
            return (Criteria) this;
        }

        public Criteria andOrderOther2EqualTo(String value) {
            addCriterion("order_other2 =", value, "orderOther2");
            return (Criteria) this;
        }

        public Criteria andOrderOther2NotEqualTo(String value) {
            addCriterion("order_other2 <>", value, "orderOther2");
            return (Criteria) this;
        }

        public Criteria andOrderOther2GreaterThan(String value) {
            addCriterion("order_other2 >", value, "orderOther2");
            return (Criteria) this;
        }

        public Criteria andOrderOther2GreaterThanOrEqualTo(String value) {
            addCriterion("order_other2 >=", value, "orderOther2");
            return (Criteria) this;
        }

        public Criteria andOrderOther2LessThan(String value) {
            addCriterion("order_other2 <", value, "orderOther2");
            return (Criteria) this;
        }

        public Criteria andOrderOther2LessThanOrEqualTo(String value) {
            addCriterion("order_other2 <=", value, "orderOther2");
            return (Criteria) this;
        }

        public Criteria andOrderOther2Like(String value) {
            addCriterion("order_other2 like", value, "orderOther2");
            return (Criteria) this;
        }

        public Criteria andOrderOther2NotLike(String value) {
            addCriterion("order_other2 not like", value, "orderOther2");
            return (Criteria) this;
        }

        public Criteria andOrderOther2In(List<String> values) {
            addCriterion("order_other2 in", values, "orderOther2");
            return (Criteria) this;
        }

        public Criteria andOrderOther2NotIn(List<String> values) {
            addCriterion("order_other2 not in", values, "orderOther2");
            return (Criteria) this;
        }

        public Criteria andOrderOther2Between(String value1, String value2) {
            addCriterion("order_other2 between", value1, value2, "orderOther2");
            return (Criteria) this;
        }

        public Criteria andOrderOther2NotBetween(String value1, String value2) {
            addCriterion("order_other2 not between", value1, value2, "orderOther2");
            return (Criteria) this;
        }

        public Criteria andOrderOther4IsNull() {
            addCriterion("order_other4 is null");
            return (Criteria) this;
        }

        public Criteria andOrderOther4IsNotNull() {
            addCriterion("order_other4 is not null");
            return (Criteria) this;
        }

        public Criteria andOrderOther4EqualTo(Integer value) {
            addCriterion("order_other4 =", value, "orderOther4");
            return (Criteria) this;
        }

        public Criteria andOrderOther4NotEqualTo(Integer value) {
            addCriterion("order_other4 <>", value, "orderOther4");
            return (Criteria) this;
        }

        public Criteria andOrderOther4GreaterThan(Integer value) {
            addCriterion("order_other4 >", value, "orderOther4");
            return (Criteria) this;
        }

        public Criteria andOrderOther4GreaterThanOrEqualTo(Integer value) {
            addCriterion("order_other4 >=", value, "orderOther4");
            return (Criteria) this;
        }

        public Criteria andOrderOther4LessThan(Integer value) {
            addCriterion("order_other4 <", value, "orderOther4");
            return (Criteria) this;
        }

        public Criteria andOrderOther4LessThanOrEqualTo(Integer value) {
            addCriterion("order_other4 <=", value, "orderOther4");
            return (Criteria) this;
        }

        public Criteria andOrderOther4In(List<Integer> values) {
            addCriterion("order_other4 in", values, "orderOther4");
            return (Criteria) this;
        }

        public Criteria andOrderOther4NotIn(List<Integer> values) {
            addCriterion("order_other4 not in", values, "orderOther4");
            return (Criteria) this;
        }

        public Criteria andOrderOther4Between(Integer value1, Integer value2) {
            addCriterion("order_other4 between", value1, value2, "orderOther4");
            return (Criteria) this;
        }

        public Criteria andOrderOther4NotBetween(Integer value1, Integer value2) {
            addCriterion("order_other4 not between", value1, value2, "orderOther4");
            return (Criteria) this;
        }

        public Criteria andOrderOther5IsNull() {
            addCriterion("order_other5 is null");
            return (Criteria) this;
        }

        public Criteria andOrderOther5IsNotNull() {
            addCriterion("order_other5 is not null");
            return (Criteria) this;
        }

        public Criteria andOrderOther5EqualTo(Integer value) {
            addCriterion("order_other5 =", value, "orderOther5");
            return (Criteria) this;
        }

        public Criteria andOrderOther5NotEqualTo(Integer value) {
            addCriterion("order_other5 <>", value, "orderOther5");
            return (Criteria) this;
        }

        public Criteria andOrderOther5GreaterThan(Integer value) {
            addCriterion("order_other5 >", value, "orderOther5");
            return (Criteria) this;
        }

        public Criteria andOrderOther5GreaterThanOrEqualTo(Integer value) {
            addCriterion("order_other5 >=", value, "orderOther5");
            return (Criteria) this;
        }

        public Criteria andOrderOther5LessThan(Integer value) {
            addCriterion("order_other5 <", value, "orderOther5");
            return (Criteria) this;
        }

        public Criteria andOrderOther5LessThanOrEqualTo(Integer value) {
            addCriterion("order_other5 <=", value, "orderOther5");
            return (Criteria) this;
        }

        public Criteria andOrderOther5In(List<Integer> values) {
            addCriterion("order_other5 in", values, "orderOther5");
            return (Criteria) this;
        }

        public Criteria andOrderOther5NotIn(List<Integer> values) {
            addCriterion("order_other5 not in", values, "orderOther5");
            return (Criteria) this;
        }

        public Criteria andOrderOther5Between(Integer value1, Integer value2) {
            addCriterion("order_other5 between", value1, value2, "orderOther5");
            return (Criteria) this;
        }

        public Criteria andOrderOther5NotBetween(Integer value1, Integer value2) {
            addCriterion("order_other5 not between", value1, value2, "orderOther5");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}